Pages
Shape Links
Shape Properties
PSSI Implementation Tracker
PSSI Implementation Tracker
Process Maps
Process Maps
Required Documents for Procurement
Required Documents for Procurement
Activities & Project Proposals
Activities & Project Proposals
Pacific Salmon Strategy Initiative
Pacific Salmon Strategy Initiative
Low Code
Low Code
•
•
AirTable
AirTable
•
•
SharePoint List
SharePoint List
•
•
Ragic
Ragic
DFO
DFO
SDPA, OCDS, IMTS, IT-Cloud
SDPA, OCDS, IMTS, IT-Cloud
Objective
Objective
Process Map
Process Map
Collaborative Teams, Details and Documents, Working Groups
Collaborative Teams, Details and Documents, Working Groups
Science – OCR Unstructured - Salmon Modernization Project
Science – OCR Unstructured - Salmon Modernization Project
EDH
EDH
IT- Secuirty
IT- Secuirty
Contracts for Data and Human Resources
Contracts for Data and Human Resources
Stewardship Directorate (Habitat Restoration Centre of Expert...
Stewardship Directorate (Habitat Restoration Centre of Expertise) – OCR Structured – (G&Cs)
Phase
Phase
Strategic Data Analytics Team
Strategic Data Analytics Team
Data Collection & Meta-Data
Data Collection & Meta-Data
Knowledge Graph
Knowledge Graph
Science Data Gaps
Science Data Gaps
EDH
EDH
Cloud Architecture
Cloud Architecture
Software Suites (Data Lineage)
Software Suites
(Data Lineage)
Office of the Chief Data Steward (OCDS)
Office of the Chief Data Steward (OCDS)
Prospective Consultants
Prospective Consultants
Data - Lake, Hub, Warehouse, Fabric, Mesh
Data - Lake, Hub,
Warehouse, Fabric,
Mesh
Supporting Documents
Supporting
Documents
Team Documents
Team Documents
Crest / Krest
Crest / Krest
Team Documents
Team Documents
Data Stewards
Data Stewards
Technical
Technical
Projects
Projects
AQUIIS
AQUIIS
Fisheries and Harbour Management (FM)
Fisheries and Harbour Management (FM)
Data Analytics Team Documents [ O – In Office| X – Away]
Data Analytics Team Documents
[
O
–
In Office| X
–
Away]
Science
Science
IT Security Analysts
IT Security Analysts
Non-PSPC Verification Approval
Non-PSPC Verification Approval
PSPC Approved
PSPC Approved
Pacific Salmon Scanner - Regional Ecosystem Effects Fish & Fi...
Pacific Salmon Scanner -
Regional Ecosystem Effects Fish
& Fisheries
Salmon Program Integration
Salmon Program Integration
OCR
OCR
Database Mapping
Database Mapping
Cloud & Data Lake
Cloud & Data Lake
Steps
Steps
SPDA Working Groups
SPDA Working Groups
DG and Management Level
DG and Management Level
National Data Council (NDC)
National Data Council
(NDC)
Data Stewardship Committee (DSC)
Data Stewardship
Committee
(DSC)
Data Governance Steering Committee (DGSC)
Data Governance Steering
Committee (DGSC)
Working Level
Working Level
Metadata Working Group
Metadata Working Group
Metadata Best Practices Sub-Working Group
Metadata Best Practices
Sub
-Working Group
Reference Data Working Group (RDWG)
Reference Data Working
Group
(RDWG)
Data Inventory Working Group (DIWG)
Data Inventory Working
Group (DIWG)
Data Sharing Agreement Working Group (DSAWG)
Data Sharing Agreement
Working Group (DSAWG)
Data Governance Working Group (DGWG)
Data Governance Working
Group
(DGWG)
E.g. FM, Science
E.g. FM, Science
Problem: Our ability to conserve and protect salmon is hamper...
Problem:
Our ability to conserve and protect salmon is hampered by our inability to deal effectively with complex information.
Solution:
A knowledge graph is a modern approach to manage and discover information, allowing more fully informed decisions, and ultima
tely improved
salmon conservation.
Why was the knowledge graph created?
A knowledge graph was created to map out the connections, or interdependencies, between DFO Pacific region applications that
use salmon data, the
databases the applications are stored in, the products the applications produce (such as dashboards, briefing notes, data sum
maries) and ultimately the
decisions the data supports. Specifically, a knowledge graph can help solve four key questions:
1.
What are the salmon data sets and where are they?
2.
Who collects and consumes the data?
3.
What products do those data sets feed into?
4.
What data sets feed into what decisions?
In short, to map how data flows from databases the data stored in to the decisions the data supports. To the best of our know
ledge, this task is novel and
had never been completed before.
What could you not do before the knowledge graph?
A knowledge graph is a great tool to understand the relationships between nodes, i.e. applications, databases, products and d
ecisions, by connecting the
nodes with edges (or arrows). Often in DFO Excel spreadsheets have been used to inventory data and identify connections. Whil
e spreadsheets can
accurately store the connections between databases, applications etc., they are not great at visually viewing the connections
and searching the connections.
With spreadsheets we could not easily find and access the connections in a visual way.
What can you 'possibly' do now with the knowledge graph?
With the knowledge graph is its current form we can visually view and understand the relationships between applications, data
bases, and products to
support decision
-
making through analytics. Relationships between entities will provide insight, trends and interconnections that may have neve
r been
considered, therefore leveraging data collaboration among data stewards, improving data harmonization standards and removing
redundancies.
Proactive vs Reactive: Significant changes performed by data stewards to their respective data values will provide real
-
time deterministic impact to the
relationship among databases. This will inform and challenge whether these changes align with the teams business strategy and
offers instant feedback.
Through an automated process, the A.I package will constantly scan and review the relationships among the various databases.
This will ensure that data
management is continually driven in an efficient way.
Priyadarshi Pal Data Architect
Priyadarshi Pal
Data Architect
(Prior work - Marine Spatial Planning, Oceans Protection Plan...
(Prior work - Marine Spatial Planning, Oceans Protection Plan, Marine Conservation Targets)
Metadata summarizes basic information about data, making finding & working with particular
instances of data easier. Metadata is needed to have a generalized structure of the information and
what is being collected
·
Metadata Best Practices Working Guide
Science-specific data gaps and their data stewards Salmon Dat...
Science-specific data gaps and their data stewards
·
Salmon Data Gaps and Issues
David Goa Data Engineer
David Goa
Data Engineer
Tan Tran Senior Data Advisor
Tan Tran
Senior Data Advisor
KPI’s
KPI’s
(Vacant) Cloud Engineer
(Vacant)
Cloud Engineer
IT SEC
IT SEC
(Vacant) Cloud Architect
(Vacant)
Cloud Architect
Strategic Data Governance & Policy Team
Strategic Data Governance & Policy Team
Vacant Strategic Data Advisor
Vacant
Strategic Data Advisor
Chief Digital Office Sector (CDOS) [Formerly IMTS]
Chief Digital Office Sector (CDOS) [Formerly IMTS]
Department of Fisheries and Oceans The Pacific Salmon Strateg...
Department of Fisheries and Oceans
The Pacific Salmon Strategy Initiative is a major transformational initiative intended to stem the decline of priority Pacifi
c salmon populations and to assist the rebuilding of stocks to sustainable levels. While the management of Pacific salmon is
focused on five species of Pacific salmon within the Pacific Region, various sectors and branches throughout the Department h
ave policy and program responsibilities related to Pacific Salmon.
As
part of the Pacific Salmon Strategic Initiative roadmap, we are in the process of implementing a cloud infrastructure of all
salmon
-
related data. The purpose for this initiative is to deploy strategic
-
informed decisions that are data
-
driven and supported by science. Currently, salmon
-
related data sources vary in different levels of complications; either data is inconsistent, have access issues, are siloed o
n prem, disconnected relationships among
databases/datasets, or insufficient tracing to single source of truth to name a few, the cloud infrastructure objective is to
solve these issues.
Data Policy team - Inventory log
Data Policy team -
Inventory log
Data Inventory, Business Meta and Prioritization (All Salmon-...
Data Inventory, Business
Meta and Prioritization (All
Salmon
-related Data)
Data Catalogue
Data Catalogue
TigerGraph
TigerGraph
Neo4J
Neo4J
Mapster
Mapster
Data Cleaning (Harmonization/Normalization)
Data Cleaning
(Harmonization/
Normalization)
Peter Lunka A-Senior Data Policy Analyst
Peter Lunka
A
-
Senior
Data Policy Analyst
EDH Portal
EDH Portal
EDH API (Operational Database)
EDH API
(Operational
Database)
Ingest data – Meta data -> map out fields -> determine values...
Ingest data –
Meta data
-> map out fields -> determine values/range (KPI) ->
harmonize fields OR normalize data [consistency]
-> map out
relationships (nodes)
– Correlation threshold (link prediction)
with software suites like Neo4J map
-> ML connection
CLAMS
CLAMS
Policy and Results Team
Policy and Results Team
Project Requirements
Project Requirements
Assessment of OCR Vendors
Assessment of OCR
Vendors
Security
Security
HR
HR
Justification
Justification
Time
Time
Cost
Cost
Approval and Procurement
Approval and
Procurement
Security
Security
Cloud
Cloud
Tobias Spears A/Manager / Head Office of the Chief Data Steward
Tobias Spears
A/Manager / Head
Office of the Chief Data Steward
Data Migration - SQL
Data Migration - SQL
George Esper Manager Database & Data Administration
George Esper
Manager
Database & Data Administration
Analytics
Analytics
Cloud Ingestion
Cloud Ingestion
Data Sources + Metadata
Data Sources +
Metadata
Karen Starkie Data Modeler/ Business Analyst
Karen Starkie
Data Modeler/
Business Analyst
Procurement
Procurement
Data Mesh/Fabric
Data Mesh/Fabric
Funding
Funding
Kayla Suhan Aquatic Science Technician
Kayla Suhan
Aquatic Science Technician
Nick Bolingbroke EG-04 Technician
Nick Bolingbroke
EG
-
04 Technician
Field Technicians
Field Technicians
NuSEDS
NuSEDS
Stream Inspection Logs (SIL)
Stream Inspection Logs (SIL)
Output – Strategic Advice
Output – Strategic Advice
Network Access Control List
Network Access
Control List
Clean Data
Clean
Data
Microsoft Purview
Microsoft Purview
Denodo
Denodo
Access Database (South Coast Servers)
Access Database
(South Coast
Servers)
Scanning
Scanning
South Coast Staff (e.g. Nicolette)
South Coast Staff (e.g. Nicolette)
Excel sheet
Excel sheet
Callibra
Callibra
Data stewards and users
Data stewards and users
Azure Data Lake
Azure Data Lake
MetaData
MetaData
Data Stewards
Data Stewards
EDH Data Catalogue Portal
EDH Data Catalogue
Portal
Informatica
Informatica
EDH API (Operational Database)
EDH API
(Operational
Database)
Database 2
Database 2
Database 1
Database 1
Database (n)
Database (n)
Federal Geospatial Platform
Federal Geospatial
Platform
Open Government/Data Portal
Open Government/
Data Portal
EDH & SDPA
EDH & SDPA
Technical MetaData
Technical MetaData
API
API
Data Catalogue
Data Catalogue
Data Cleaning (Harmonization/Normalization)
Data Cleaning
(Harmonization/
Normalization)
Single Source of Truth is kept intact
Single Source of Truth is kept intact
Users
Users
Output: Software suite app / Data Lake
Output: Software
suite app / Data
Lake
‘Readily-available’ datasets
‘Readily-available’
datasets
Ingestion Layer - Performs data migrations via batch and stre...
Ingestion Layer -
Performs data migrations via batch and streaming methods. We will be using services such as open portals or API pipeline from
other cloud
services. Review Databases and connect with Data Stewards to determine validity of data integration
Storage Layer
-
Microsoft Azure Data Lake Storage (Work with Cloud Architect)
Catalog Layer
Working with IM/IT central catalog services and lake formation if we require data level security approval (SOS)
Processing Layer
Cloud infrastructure and support of cloud processing
-
review Microsoft Azure API
Consumption Layer
For querying data and exploring data users. For AI we are using TensorFlow to build, train, and deploy models.
Models can be exposed as a service to be consumed by apps or will be published. Finally for visualization, Tableau and Power
BI. We configured a Power BI gateway
so Azure Power BI server can connect to our backends.
Vacant Junior Data Analyst
Vacant
Junior Data Analyst
Sarah Brooks Junior Data Analyst Co-op
Sarah Brooks
Junior Data Analyst
Co
-
op
(Vacant) Data Engineer
(Vacant)
Data Engineer
Business Glossary and Standards Identification
Business Glossary and
Standards Identification
Data as an Asset Project – Valuing databases and datasets acr...
Data as an Asset Project –
Valuing databases and
datasets across the Pacific
Complete Data to Decisions Map using Business MetaData and In...
Complete Data to Decisions
Map using Business
MetaData and Inventory
Database Examples
Database Examples
•
•
MySql
MySql
•
•
Postgres
Postgres
•
•
SQLite
SQLite
•
•
MariaDB
MariaDB
External Portal Examples:
External Portal Examples:
•
•
Pacific Salmon Foundation
Pacific Salmon Foundation
•
•
Canada Energy Regulatory #1
Canada Energy Regulatory #1
•
•
Canada Energy Regulatory #2
Canada Energy Regulatory #2
•
•
Statistic Canada
Statistic Canada
•
•
Natural Resource Canada #1
Natural Resource Canada #1
•
•
Natural Resource Canada #2
Natural Resource Canada #2
Microsoft Azure Catalog
Microsoft Azure Catalog
DFO’s EDH (In Development)
DFO’s EDH (In Development)
Internal Portal Examples:
Internal Portal Examples:
•
•
ThinkData
ThinkData
•
•
Tableau
Tableau
•
•
•
•
Adastra – RFP/RFQ Contract (procurement)
Adastra – RFP/RFQ Contract (procurement)
Adastra Overview and Capabilities
Adastra Overview
and Capabilities
Kevin O’Connor Business Analyst
Kevin O’Connor
Business Analyst
EDH Onboarding Methodologies
EDH Onboarding Methodologies
Document Recovery Project
Document
Recovery Project
Document Dissector PoC
Document
Dissector PoC
Cloud Data
Cloud Data
David Collister A/Manager Office of the Chief Data Steward
David Collister
A/Manager
Office of the Chief Data Steward
Justin Mundy Lead
Justin Mundy
Lead
Storage
Storage
Scanning
Scanning
Completion Date: Expected November
Completion Date: Expected November
Implementation
Implementation
Extraction
Extraction
Review
Review
UI
UI
JSON
JSON
Field Experts (in House) / Outsourced
Field Experts (in
House) /
Outsourced
Data to Decisions
Data to Decisions
Document Dissector PPT
Document
Dissector
PPT
Databases
Databases
Document Overview Cloud Request
Document Overview
Cloud Request
ReadMe Data Redundancy
ReadMe
Data Redundancy
Security
Security
Guy Demers A/Team Leader, Risk Management
Guy Demers
A/Team Leader,
Risk Management
Simon Dufour Lead
Simon Dufour
Lead
Azure Data Catalogue Suite
Azure Data Catalogue
Suite
Business Management Integration and Engagement
Business Management Integration and
Engagement
Vacant Solutions Architect
Vacant
Solutions Architect
Erfan Ahmed Project Manager
Erfan Ahmed
Project Manager
Christene Ostapczuk IT Technical Advisor
Christene Ostapczuk
IT Technical Advisor
Daniel Warkentin A/ Manager (Technical Advisor)
Daniel Warkentin
A/ Manager (Technical Advisor)
Richard Kiefl A/ Director IMTS
Richard Kiefl
A/ Director IMTS
Application Rationalization Initiatives
Application
Rationalization Initiatives
Tim Mattimoe Manager Database, Applications & Platforms Servi...
Tim Mattimoe
Manager
Database, Applications
& Platforms Services
Business Intake / Proposal
Business Intake /
Proposal
ETL
ETL
PSSI Digital Salmon Data Integration (Data Repository)
PSSI Digital Salmon Data
Integration
(Data Repository)
Spatial vs Non-Spatial Data
Spatial vs
Non
-Spatial Data
Data Inventory
Data Inventory
Vacant EC-02 Junior Data Analyst
Vacant
EC
-
02
Junior Data Analyst
Aswea Porter Aquatic Science Biologist South Coast
Aswea Porter
Aquatic Science Biologist
South Coast
Erin Rechisky Section Head - Aquatic Science Biologist South ...
Erin Rechisky
Section Head
-
Aquatic Science Biologist
South Coast
PSSI IT Requirements Survey
PSSI IT
Requirements Survey
Brenda McIntyre Manager Intake - Software Solutions
Brenda McIntyre
Manager
Intake
-
Software Solutions
Chris O’Grady GIS and Data Coordinator
Chris O’Grady
GIS and Data Coordinator
Krista, Sandberg Senior Data and Public Reporting Coordinator
Krista, Sandberg
Senior Data and
Public Reporting Coordinator
Faith Yu Service Manager
Faith Yu
Service Manager
Dana Hsu Fishery Information Assistant
Dana Hsu
Fishery Information Assistant
Data Priority Framework
Data Priority
Framework
Pacific Data Lakehouse Identification of Early Adopters
Pacific Data Lakehouse
Identification of Early
Adopters
Metadata Project
Metadata Project
Karin Mathias Data Analytics Lead South Coast
Karin Mathias
Data Analytics Lead
South Coast
John Davidson Data Analyst
John Davidson
Data Analyst
Martin Huang Data Analyst
Martin Huang
Data Analyst
PACHarv-3 Process Map
PACHarv-3
Process Map
AMD Process Map
AMD
Process Map
C/K rest Process Map
C/K rest
Process Map
NuSEDS Process Map
NuSEDS
Process Map
Reed Orpen Junior Programmer South Coast
Reed Orpen
Junior Programmer
South Coast
Sue Grant Program Head
Sue Grant
Program Head
Bronwyn MacDonald Analytical Biologist
Bronwyn MacDonald
Analytical Biologist
Data Management Services - Comparisons
Data Management
Services
- Comparisons
Scanner Process Map
Scanner
Process Map
DFO-PSSI Data Lake
DFO-PSSI
Data Lake
IT-Security Requirements
IT-Security Requirements
SOS
SOS
SRCL
SRCL
ISO27017
ISO27017
ISO27018
ISO27018
SOC2 – Type II
SOC2 – Type II
ISO 27001
ISO 27001
Signature-Approval
Signature-Approval
Audit Checklist PBML System Support Team
Audit Checklist PBML
System Support Team
Audit Checklist PBML PSDM
Audit Checklist PBML
PSDM
Audit Compliance Evidence
Audit Compliance
Evidence
Cloud SaaS PBML System Support Team
Cloud SaaS PBML
System Support Team
NuSEDS / FOS
NuSEDS / FOS
Kayla Suhan Aquatic Science Technician
Kayla Suhan
Aquatic Science Technician
Yi Xu Program Head
Yi Xu
Program Head
Graham Van der Slagt Strategic Advisor
Graham Van der Slagt
Strategic Advisor
Jaimi Gardner Manager
Jaimi Gardner
Manager
Christian Guay Regional Security Officer
Christian Guay
Regional Security Officer
Data Priority Framework Weight
Data Priority
Framework Weight
Map Standardized Operating Procedures (Process Map)
Map Standardized
Operating Procedures
(Process Map)
Extract Operational and Functional issues
Extract Operational and
Functional issues
Group and categorize issues
Group and categorize
issues
Consult with IMTS Team - Cross reference with PSSI-IT Survey
Consult with IMTS Team -
Cross reference with PSSI
-
IT Survey
Audit - Extract outstanding issues & create Use-Case
Audit
-
Extract outstanding
issues & create Use
-
Case
Report to Management & Present issues with proposed solutions
Report to Management &
Present issues with
proposed solutions
Funding
Funding
Deploy Strategic Operations (internal/external)
Deploy Strategic
Operations (internal/
external)
A/Director Cyber Security
A/Director Cyber Security
Remi Gagnon Cybersecurity Risk Management
R
e
mi Gagnon
Cybersecurity Risk Management
Manager
Manager
Eric Louis-Seize Cybersecurity Risk Management
Eric Louis-Seize
Cybersecurity Risk Management
Consult with IT Teams (i.e. IMTS/IT/EDH/Cloud/SEC)
Consult with IT Teams (i.e.
IMTS/IT/EDH/Cloud/SEC)
Create proposed IT-solutions
Create proposed IT-
solutions
Eric Quan
Eric Quan
Daniel Warkentin
Daniel
Warkentin
Dennis Klassen Senior Advisor
Dennis Klassen
Senior Advisor
Jessica Chan Program Advisor
Jessica Chan
Program Advisor
Reggie Gill Program Officer
Reggie Gill
Program Officer
Rishika Selvakumar Program Assistant
Rishika Selvakumar
Program Assistant
Piper-Lynn Brady Salmon Stock Assessment Technician South Coast
Piper-Lynn Brady
Salmon Stock
Assessment Technician
South Coast
Vacant EC-05 Data Analyst
Vacant
EC
-
05
Data Analyst
Informatica
Informatica
Riham Elhabyan Senior Policy Advisor
Riham Elhabyan
Senior Policy Advisor
Lee Croft Analyst
Lee Croft
Analyst
Ayan Qadir Junior Data Analyst Co-op
Ayan Qadir
Junior Data Analyst
Co
-
op
Data Stories Examples
Data Stories Examples
•
•
•
•
•
•
AmCharts COVID
AmCharts COVID
NASA Images
NASA Images
PhD Gender Gap
PhD Gender Gap
Olivier Sabourin Senior Data Specialist
Olivier Sabourin
Senior Data Specialist
Tan Tran Senior Data Advisor PSSI
Tan Tran
Senior Data Advisor
PSSI
Julian Kirby Senior Policy Advisor
Julian Kirby
Senior Policy Advisor
OCDO Committees
OCDO Committees
PSSI Recreational Catch Monitoring – Data IT Sub Group
PSSI Recreational Catch
Monitoring
– Data IT Sub
Group
Artificial Intelligence Working Group (AI WG)
Artificial Intelligence
Working Group
(AI WG)
Regional Data Council (RDC)
Regional Data Council (RDC)
Strategic Data Working Group
Strategic Data Working
Group
Regional Spatial Data Coordination WG
Regional Spatial Data
Coordination WG
DFO - Procurement Team
DFO - Procurement Team
Required Documents
Required Documents
Option #1) Consultants – Services (SaaS)
Option #1) Consultants – Services (SaaS)
Option #3) Software Acquisitions (Stand alone) – On Prem
Option #3) Software Acquisitions (Stand alone) – On Prem
Option #2) Software Acquisitions – On Cloud (SaaS)
Option #2) Software Acquisitions – On Cloud (SaaS)
Sole Source
Sole Source
CDOS
CDOS
Director
Director
Senior Manager
Senior Manager
Contract Officer
Contract Officer
Team Leader Contracting Officer
Team Leader
Contracting Officer
Contracting Officer
Contracting Officer
Resource Planning Officer
Resource Planning
Officer
HR Documents – Onboarding
HR Documents – Onboarding
Students
Students
Procurement Services Hub Forms
Procurement Services Hub
Forms
RFP
RFP
Hub Officer
Hub
Officer
ACAN
ACAN
Term/Casual/Indeterminate
Term/Casual/Indeterminate
PSSI Recreational Catch Monitoring WG
PSSI Recreational Catch
Monitoring WG
EDH Data Catalogue
EDH Data Catalogue
Eric’s Files
Eric’s Files
Onboarding Material
Onboarding Material
Data Inventory (DMApps)
Data Inventory (DMApps)
Structured
Structured
Unstructured
Unstructured
Data Portal
Data Portal
Seating Plan Bookings
Seating Plan Bookings
Sr Procurement Officer
Sr Procurement Officer
Products
Products
Project Architecture
Project Architecture
PSSI with Science
PSSI with Science
Data Science & Advanced Analytics
Data Science & Advanced
Analytics
Engagement and Learning
Engagement and Learning
Tools, Resources and Guides
Tools, Resources and Guides
Project Plans
Project Plans
SDPA
SDPA
PSTB - Restoration Centre of Expertise
PSTB - Restoration Centre of Expertise
EMB – Integrated Planning for Salmon Ecosystem (IPSE)
EMB – Integrated Planning for Salmon Ecosystem (IPSE)
EMB – Fish and Fish Habitat Protection Program (FFHPP)
EMB – Fish and Fish Habitat Protection Program (FFHPP)
FM - Quebec
FM - Quebec
Stock Assessment
Stock Assessment
Data Quality
Data Quality
Data Ethics and Responsible AI Working Group (DERAI WG)
Data Ethics and Responsible
AI Working Group
(DERAI WG)
DFO-PSSI-HR and Administration
DFO-PSSI-HR and Administration
HR Branch
HR Branch
Fast-Track
Fast-Track
OCDS Documents
OCDS Documents
Muna Sayid Procurement Specialist
Muna Sayid
Procurement Specialist
Mallorie Dawson Team Lead Procurement Specialist
Mallorie Dawson
Team Lead
Procurement Specialist
Adastra Overview and Capabilities
Adastra
Overview and
Capabilities
Software Licensing Supply Arrangement
Software Licensing
Supply Arrangement
Buy and Sell
Buy and Sell
RFP – Task-Based Information Professional Services (TBIPS)
RFP – Task-Based Information
Professional Services (TBIPS)
RFP – Task and Solutions Professional Services (TSPS)
RFP – Task and Solutions
Professional Services (TSPS)
Sole-Source (DFO) < $40K
Sole-Source (DFO) < $40K
RFP Process
RFP Process
SOMC / SOW
SOMC / SOW
Purchase Requisition
Purchase Requisition
Cost Centre Manager
Cost Centre Manager
Mandatory / Flex Grid
Mandatory / Flex
Grid
SOSA – Standing Offer and Supply Arrangements Application
SOSA – Standing Offer and
Supply Arrangements Application
Contract or Software License Deadlines – who can we contact?
Contract or Software
License Deadlines
– who
can we contact?
Assyst
Assyst
ACAN – Advance Contract Award Notice <15 calendar days
ACAN – Advance Contract
Award Notice <15 calendar days
Buy and Sell
Buy and Sell
Statement of Capability – Will extend ACAN to 30 days
Statement of Capability
– Will extend ACAN to 30 days
RC Delegated Manager < $20k
RC Delegated Manager < $20k
PSPC Contract >25K – requires 3 months
PSPC Contract >25K –
requires 3 months
SSC (If falls within Mandate)
SSC (If falls within Mandate)
PSPC
PSPC
PSPC - Delegation
PSPC -
Delegation
assigned
assigned
DFO – Procurement Services
DFO –
Procurement
Services
Sole-Source (DFO) < $200K
Sole-Source (DFO) < $200K
Request Eric to send email about dedicated PSSI Procurement O...
Request Eric to send email
about dedicated PSSI
Procurement Officer to
Mallorie
– Include Matt and
Christophe
SOW
SOW
Sole Source Justification
Sole Source
Justification
Quote from Vendor
Quote from Vendor
Security Requirement Check List (SRCL)
Security
Requirement Check
List (SRCL)
Intellectual Property Form
Intellectual
Property Form
Francis Gosselin
Francis Gosselin
Patrizia Marinelli
Patrizia Marinelli
Joanne Lynch
Joanne Lynch
Nancy Savaria
Nancy Savaria
Meenu Bhatia
Meenu Bhatia
Christine Demers
Christine Demers
List of validated Post-Secondary Academic Institutions and Pr...
List of validated Post-Secondary Academic
Institutions and Programs
SOW
SOW
Security Requirement Check List (SRCL)
Security
Requirement Check
List (SRCL)
Intellectual Property Form
Intellectual
Property Form
Procurement Intake Form
Procurement Intake
Form
SOW
SOW
Security Requirement Check List (SRCL)
Security
Requirement Check
List (SRCL)
Intellectual Property Form
Intellectual
Property Form
Quote from Vendor
Quote from Vendor
Advertising - Poster
Advertising - Poster
SPDA SOMC – EC05
SPDA SOMC – EC05
All-in-one non-advertised form
All-in-one
non
-advertised form
Job Description Analytics Team
Job Description
Analytics Team
Student Salary
Student Salary
SFU Contact
SFU Contact
UBC Contact
UBC Contact
HR DFO-PSSI
HR DFO-PSSI
Kellina Lang HR Administrator
Kellina Lang
HR Administrator
Sherry Luo Strategic Data Analyst
Sherry Luo
Strategic Data Analyst
Audit
Audit
Analytics Team SOMC – EC05
Analytics Team
SOMC – EC05
Roles & Responsibilities
Roles &
Responsibilities
Pacific Salmon Data Modernization Charter
Pacific Salmon Data
Modernization
Charter
2. Salmon 101 Deck (June 2022)
2. Salmon 101
Deck (June 2022)
3. PSSI Information Session
3. PSSI Information
Session
1. Onboarding Handbook
1. Onboarding
Handbook
4. PSEC (July 2022)
4. PSEC (July 2022)
5. PSSI (Dec 2021)
5. PSSI (Dec 2021)
6. PSSI Data & IT
6. PSSI Data
& IT
7. Strategic Data Workshop (2022)
7. Strategic Data
Workshop (2022)
2023 PSSI Project Charter Pacific Salmon Data Portal (March 23)
2023 PSSI Project
Charter Pacific Salmon
Data Portal (March 23)
DMApps
DMApps
Azure Purview Access
Azure Purview
Access
Azure Blob Portal
Azure Blob
Portal
Competitive Solicitated Contract
Competitive
Solicitated Contract
Task Authorization Contract
Task Authorization
Contract
Standing Offer
Standing Offer
Supply Arrangement
Supply Arrangement
Acquisition Card
Acquisition Card
Contractual Arrangements
Contractual
Arrangements
2023 Pacific Salmon Management Activities Matrix
2023 Pacific Salmon
Management Activities
Matrix
Project Charter Pacific Salmon Portal
Project Charter
Pacific Salmon Portal
Data Portal - Internal
Data Portal -
Internal
Science Branch Overview (2023)
Science Branch
Overview (2023)
Generic Welcome Email
Generic Welcome
Email
Data Inventory Web App Proposal
Data Inventory
Web App Proposal
DMApps Documentation
DMApps
Documentation
Data Hub Instructions & Background
Data Hub
Instructions
& Background
OCR SOW
OCR SOW
IT-SEC Requirements
IT-SEC
Requirements
Sprints
Sprints
OCR Proposal
OCR
Proposal
RFP Criteria Evaluation
RFP Criteria
Evaluation
Presentation
Presentation
Data Portal
Data Portal
Cynthia Logan Lead Advisor
Cynthia Logan
Lead Advisor
Marisa Ramey A/ Senior Data Analyst
Marisa Ramey
A/ Senior Data Analyst
Vacant Logistics Coordinator
Vacant
Logistics Coordinator
Dat Pham Data Analyst
Dat Pham
Data Analyst
Vacant Policy Advisor/Economist
Vacant
Policy Advisor/Economist
PowerBI API Connections
PowerBI API
Connections
Code
Code
WG Participation List
WG Participation List
Samples
Samples
Pacific Salmon Data Internal Engagement
Pacific Salmon Data
Internal Engagement
RDC Presentation 2022
RDC Presentation
2022
ClickUP
ClickUP
RDC Presentation 2023
RDC Presentation
2023
Samples
Samples
David Onak Data Analyst
David Onak
Data Analyst
Bassam El-Daya
Bassam El-Daya
What is a DataLake?
What is
a DataLake?
Patrick Gunville Manager EDH Onboarding
Patrick Gunville
Manager
EDH Onboarding
Tarun Bagga Consultant Artificial Intelligence
Tarun Bagga
Consultant
Artificial Intelligence
Jaswinder Singh Consultant Data Modeller
Jaswinder Singh
Consultant
Data Modeller
Azure Storage Guide
Azure Storage
Guide
PaRR
PaRR
Summary of Proposals
Summary of
Proposals
Joel Harding Section Head
Joel Harding
Section Head
Kayi Chan Sr Geo-Spatial and Database Specialist
Kayi Chan
Sr Geo
-
Spatial and
Database Specialist
Natalie Mahara Restoration Biologist
Natalie Mahara
Restoration Biologist
G&C Final Reports
G&C
Final Reports
OCR Proposal
OCR Proposal
PoC Requirements
PoC
Requirements
Document Intelligence
Document Intelligence
SQL Warehouse Databricks
SQL Warehouse
Databricks
Azure Databricks ML
Azure
Databricks ML
Azure OpenAI subscription
Azure
OpenAI subscription
Pipeline
Pipeline
Model
Model
Azure Storage (Gold)
Azure
Storage
(Gold)
Project-ID
Project-ID
Azure Storage (Bronze)
Azure
Storage
(Bronze)
Open Document types -> PDF
Open Document
types
-> PDF
Azure Databricks (Code)
Azure
Databricks
(Code)
Save tables
Save tables
Cloud Services Innovation Request
Cloud Services
Innovation Request
Save
Save
Output
Output
Data Dictionary
Data Dictionary
Saved as table
Saved as table
Data Analytics Team Who are we?
Data Analytics Team
Who are we?
Dashboards & Reports
Dashboards
& Reports
SPDA SOMC – EC02
SPDA SOMC – EC02
Khaled Sultani Analyst
Khaled Sultani
Analyst
Project Architecture Swimlanes
Project Architecture
Swimlanes
Ann-Marie Huang Management Strategy Evaluation Analyst
Ann-Marie Huang
Management Strategy
Evaluation Analyst
Diana Dobson Stock Assessment Biologist
Diana Dobson
Stock Assessment
Biologist
State of the Salmon Resource
State of the
Salmon Resource
Form-implementation Flow diagram
Form-implementation
Flow diagram
ERD
ERD
DFO All Staff Deck
DFO All Staff
Deck
Salmon Outlook 2023
Salmon Outlook
2023
Roles & Responsibilities
Roles &
Responsibilities
DFO-PSSI Power Point Template
DFO-PSSI
Power Point
Template
Documents & Presentations
Documents
&
Presentations
CDOS Work-level documents
CDOS
Work
-level
documents
OpenAI Code
OpenAI
Code
Access API-Key
Access
API
-Key
access
access
access
access
access
access
Diagrams
Diagrams
PSSI Holiday Tracker
PSSI Holiday
Tracker
OCDS Holiday Tracker
OCDS Holiday
Tracker
Escapement Proposal
Escapement
Proposal
Catch and Effort Proposal
Catch and Effort
Proposal
Outlook Proposal
Outlook
Proposal
Doc2PDF
Doc2PDF
OCR Final
OCR Final
Python Learning Series
Python Learning
Series
Member | Monday | Tuesday |Wednesday | Thursday (O) |Friday T...
Member
| Monday
| Tuesday
|Wednesday
| Thursday (O)
|Friday
Tan Tran (T)
7:00am
-
6:00pm
7:00am
-
6:00pm (O)
7:00am
-
6:00pm (O)
7:00am
-
6:00pm
7:00am
-
6:00pm
David Onak (D)
8:00am
-
4:00pm
8:00am
–
4:00pm (O)
8:00am
-
4:00pm (O)
8:00am
-
4:00pm
8:00am
–
4:00pm
Hayden Yan (H)
9:00am
–
5:00pm
9:00am
–
5:00pm (O)
9:00am
–
5:00pm (O)
9:00am
–
5:00pm
9:00am
–
5:00pm (Flex)
Dat Pham (P)
9:00am
–
5:00pm
9:00am
–
5:00pm (O)
9:00am
–
5:00pm
9:00am
–
5:00pm
9:00am
–
5:00pm (O)
Ayan Qadir(M)
9:00am
–
5:00pm
9:00am
–
5:00pm
9:00am
–
5:00pm (O)
9:00am
–
5:00pm
9:00am
–
5:00pm (O)
Yuchen Wang Senior Policy Advisor
Yuchen Wang
Senior Policy Advisor
Organizational Chart
Organizational Chart
AirTable
AirTable
OCR Software Assessment
OCR Software
Assessment
Analytics Team SOMC – EC02
Analytics Team
SOMC
– EC02
SSC Environment Walk-through
SSC Environment
Walk
-through
Hybrid Work Arrangement Agreement
Hybrid Work Arrangement
Agreement
Data Analytics Research Paper
Data Analytics
Research Paper
Generative A.I
Generative A.I
RCOE Prompt History
RCOE Prompt
History
Azure WebApps
Azure WebApps
Prompt Engineering
Prompt
Engineering
OpenAI-ChatGPT Models and Optimization Research
OpenAI-ChatGPT
Models and
Optimization
Research
Azure VM
Azure VM
Personal Identifiable Information
Personal Identifiable
Information
OpenAI-ChatGPT LLM Comparisons & Cost Analysis
OpenAI-ChatGPT
LLM Comparisons
&
Cost Analysis
RCOE
RCOE
IPSE
IPSE
FFHPP
FFHPP
Science
Science
Eric Quan Manager, Strategic Data Policy and Analytics
Eric Quan
Manager,
Strategic Data Policy and Analytics
Dan Sherville Strategic Data Advisor
Dan Sherville
Strategic Data Advisor
Hayden Yan Data Analyst
Hayden Yan
Data Analyst
OpenAI Reference & Citations
OpenAI
Reference &
Citations
FM - QC
FM - QC
FM
FM
OCR Web Guide
OCR Web
Guide
Josee Chabot Technical Advisor
Josee Chabot
Technical Advisor
Kayi Chan Program Head
Kayi Chan
Program Head
Joel Harding Section Head
Joel Harding
Section Head
Alston Bonamis Manager
Alston Bonamis
Manager
Chantelle Caron Section Head
Chantelle Caron
Section Head
Thomas Appleby Senior Biologist
Thomas Appleby
Senior Biologist
Jeska Gagnon Section Head
Jeska Gagnon
Section Head
Lisa Stychar Environmental Planner
Lisa Stychar
Environmental
Planner
Nathan Ferguson Biologist
Nathan Ferguson
Biologist
Jeska Gagnon Section Head
Jeska Gagnon
Section Head
Amos Chow Integrated Fisheries Data Manager
Amos Chow
Integrated Fisheries Data Manager
Vincent Remillard Analyst
Vincent Remillard
Analyst
Judy Dore Manager
Judy Dore
Manager
PMA Template
PMA Template
Azure Databricks
Azure Databricks
OCR Script Technical Process
OCR Script
Technical Process
Classify and Extract Model Training
Classify and Extract
Model Training
OpenAI
OpenAI
Declan Embury Acting Regional Data Coordinator
Declan Embury
Acting
Regional Data Coordinator
Datasets
Datasets
Contents
Contents
Minh Doah Database Analyst
Minh Doah
Database Analyst
Zhipeng Wu Technician
Zhipeng Wu
Technician
Tom Bird Research Scientist
Tom Bird
Research Scientist
Shelee Hamilton Head, Fishery & Assessment Data Section
Shelee Hamilton
Head,
Fishery & Assessment Data Section
Nicholas Komick MRP Analytics Program Head
Nicholas Komick
MRP Analytics Program Head
Nick Bolingbroke Technician
Nick Bolingbroke
Technician
Allan Reyes Consultant – Software Dev
Allan Reyes
Consultant
–
Software Dev
Neeha Lakkineni Consultant – Software Dev
Neeha Lakkineni
Consultant
–
Software Dev
Omar Ibrahim Manager
Omar Ibrahim
Manager
Federic Goulet Technical Advisor
Federic Goulet
Technical Advisor
Building ID Badge
Building ID Badge
Azure Certifications (AZ-900, DP-203, DP-600)
Azure Certifications
(AZ
-900, DP-203, DP-600)
Azure Resources (WebApps, Blob Storage, etc)
Azure Resources
(WebApps, Blob Storage, etc)
Google Analytics
Google Analytics
Project Plans
Project Plans
PSSI and SDPA
PSSI and SDPA
Data Portal - External
Data Portal -
External
Salmon Scanner
Salmon Scanner
MyWork Arrangement
MyWork Arrangement
Renald Bilodeau Support Analyst
Renald Bilodeau
Support Analyst
Collaborative Services & Productivity
Collaborative Services &
Productivity
Mathieu Chiasson Manager
Mathieu Chiasson
Manager
Michael Violin Technical Analyst - Designer
Michael Violin
Technical Analyst
-
Designer
Jacob Zhou Technical Advisor - Dev
Jacob Zhou
Technical Advisor
-
Dev
Elyse Giroux Team Lead
Elyse Giroux
Team Lead
IT Cloud Team
IT Cloud Team
Céleste Grodesky Team Lead
Céleste Grodesky
Team Lead
Oksana Korol Solutions Cloud Architect
Oksana Korol
Solutions Cloud Architect
Alex Imray Papineau Junior Programmer
Alex Imray Papineau
Junior Programmer
Cloud Intake
Cloud
Intake
Cloud Services Innovation Request Forms
Cloud Services Innovation
Request Forms
Mehtab Chhina Coop Junior Data Analyst
Mehtab Chhina
Coop
Junior Data Analyst
OCDS Training Request
OCDS Training Request
ClickUp Guidelines
ClickUp Guidelines
Git Best Practices
Git Best Practices
Kyle Schellen Coop Junior Data Analyst
Kyle Schellen
Coop
Junior Data Analyst
Enterprise Conceptual Architecture Team (ECAT)
Enterprise Conceptual Architecture Team
(ECAT)
Enterprise solution architecture Team (ESAT)
Enterprise solution architecture Team (ESAT)
Data Architecture Review Board (DARB)
Data Architecture Review Board (DARB)
Digital Labs
Digital Labs
Leo Chavez Manager
Leo Chavez
Manager
Natalie Murray IT Team Lead
Natalie Murray
IT Team Lead
Marco Niederegger Developer
Marco Niederegger
Developer
Infrastructure Systems - Mac & Linux Support Team
Infrastructure Systems -
Mac & Linux Support Team
Lawrence Greening IT Analyst
Lawrence Greening
IT Analyst
Nicolas Kendall, Analyst
Nicolas Kendall,
Analyst
Elaine Chan HR Advisor
Elaine Chan
HR Advisor
Kajal Bhardwaj AS-02 Admin Coordinator
Kajal Bhardwaj
AS
-02
Admin Coordinator
Rehal Herpreat CR-04 Administrator
Rehal Herpreat
CR
-04
Administrator
Coralie Harper CR-04 Administrative Clerk
Coralie Harper
CR
-04
Administrative Clerk
Ameerah Buksh CR-04 Administrative Clerk
Ameerah Buksh
CR
-04
Administrative Clerk
Roberta King Business Manager
Roberta King
Business Manager
Gavin Ng Finance Administrator
Gavin Ng
Finance Administrator
Samuel Ko IT Risk Management Analyst
Samuel Ko
IT Risk Management
Analyst
Bill Yuan IT Senior Advisor
Bill Yuan
IT Senior Advisor
ESAT Agenda & Workflow
ESAT Agenda &
Workflow
Solution Architecture Standards
Solution Architecture
Standards
Cloud Operations and Application Services
Cloud Operations and
Application Services
Marc Desrosiers Manager
Marc Desrosiers
Manager
Ghizal Mehdi IT Analyst
Ghizal Mehdi
IT Analyst
AD-GROUPS
AD-GROUPS
A.I Incubator
A.I Incubator
A.I PSSI + OCDS Usecases
A.I PSSI + OCDS
Usecases